<?php
include("./include/config.inc.php");

$regArray = array();
$j = 0;
$register = "SELECT registerId, fName, mName, sName, gender, city, address, 
                    postalCode, contactNo, webSite, email, userName, password
               FROM register";
$registerRes = mysql_query($register);
while($registerRow = mysql_fetch_array($registerRes))
{
  $regArray[$j]['registerId']  = $registerRow['registerId'];
  $regArray[$j]['fName']       = $registerRow['fName'];
  $regArray[$j]['mName']       = $registerRow['mName'];
  $regArray[$j]['sName']       = $registerRow['sName'];
  $regArray[$j]['gender']      = $registerRow['gender'];
  $regArray[$j]['city']        = $registerRow['city'];
  $regArray[$j]['address']     = $registerRow['address'];
  $regArray[$j]['postalCode']  = $registerRow['postalCode'];
  $regArray[$j]['contactNo']   = $registerRow['contactNo'];
  $regArray[$j]['webSite']     = $registerRow['webSite'];
  $regArray[$j]['email']       = $registerRow['email'];
  $regArray[$j]['userName']    = $registerRow['userName'];
  $regArray[$j]['password']    = $registerRow['password'];
  $j++;
}
$smarty->assign("regArray",$regArray);
$smarty->display("register.tpl");
?>